Видео ютуба по тегу Structured Reference In Data Validation

Создайте список проверки данных из таблицы Excel... ПРАВИЛЬНЫМ СПОСОБОМ!

Introduction to structured references

Lock Structured References in Excel Tables (No More Formula Errors)

How to Use Structured References in Excel: Table, Column, and Item Specifiers

Master Excel Tables, structured references, data validation, and dropdowns

Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)

Create Data Validation List from Excel Table (3 Easy Ways)

Excel - Data Validation with the INDIRECT Function - Excel Advanced

Excel Table: Structured References

1. Excel Data Validation Across Multiple Workbooks

Создание нескольких зависимых раскрывающихся списков в Excel [ЛЕГКО]

Excel Qualified en unqualified structured references

How to Use Excel Tables Structured References